{
    "cells": [
        {
            "cell_type": "code",
            "execution_count": 3,
            "source": [
                "import pandas\r\n",
                "data = pandas.read_excel('D:/proj/jupyter_demo/W020200709292792106069.xls')\r\n"
            ],
            "outputs": [],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 16,
            "source": [
                "data[data['所在地'].str.contains(\"广州\")]"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "        序号        学校名称       学校标识码    主管部门  所在地 办学层次   备注\n",
                            "1885  1886        中山大学  4144010558     教育部  广州市   本科  NaN\n",
                            "1886  1887        暨南大学  4144010559   中央统战部  广州市   本科  NaN\n",
                            "1888  1889      华南理工大学  4144010561     教育部  广州市   本科  NaN\n",
                            "1889  1890      华南农业大学  4144010564     广东省  广州市   本科  NaN\n",
                            "1891  1892      广州医科大学  4144010570     广东省  广州市   本科  NaN\n",
                            "...    ...         ...         ...     ...  ...  ...  ...\n",
                            "2020  2021    广东青年职业学院  4144014361     广东省  广州市   专科  NaN\n",
                            "2021  2022    广州东华职业学院  4144014362  广东省教育厅  广州市   专科   民办\n",
                            "2023  2024  广东舞蹈戏剧职业学院  4144014407     广东省  广州市   专科  NaN\n",
                            "2026  2027  广东生态工程职业学院  4144014509     广东省  广州市   专科  NaN\n",
                            "2032  2033  广州卫生职业技术学院  4144014592     广东省  广州市   专科  NaN\n",
                            "\n",
                            "[82 rows x 7 columns]"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>序号</th>\n",
                            "      <th>学校名称</th>\n",
                            "      <th>学校标识码</th>\n",
                            "      <th>主管部门</th>\n",
                            "      <th>所在地</th>\n",
                            "      <th>办学层次</th>\n",
                            "      <th>备注</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>1885</th>\n",
                            "      <td>1886</td>\n",
                            "      <td>中山大学</td>\n",
                            "      <td>4144010558</td>\n",
                            "      <td>教育部</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>本科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1886</th>\n",
                            "      <td>1887</td>\n",
                            "      <td>暨南大学</td>\n",
                            "      <td>4144010559</td>\n",
                            "      <td>中央统战部</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>本科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1888</th>\n",
                            "      <td>1889</td>\n",
                            "      <td>华南理工大学</td>\n",
                            "      <td>4144010561</td>\n",
                            "      <td>教育部</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>本科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1889</th>\n",
                            "      <td>1890</td>\n",
                            "      <td>华南农业大学</td>\n",
                            "      <td>4144010564</td>\n",
                            "      <td>广东省</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>本科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1891</th>\n",
                            "      <td>1892</td>\n",
                            "      <td>广州医科大学</td>\n",
                            "      <td>4144010570</td>\n",
                            "      <td>广东省</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>本科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>...</th>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2020</th>\n",
                            "      <td>2021</td>\n",
                            "      <td>广东青年职业学院</td>\n",
                            "      <td>4144014361</td>\n",
                            "      <td>广东省</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>专科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2021</th>\n",
                            "      <td>2022</td>\n",
                            "      <td>广州东华职业学院</td>\n",
                            "      <td>4144014362</td>\n",
                            "      <td>广东省教育厅</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>专科</td>\n",
                            "      <td>民办</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2023</th>\n",
                            "      <td>2024</td>\n",
                            "      <td>广东舞蹈戏剧职业学院</td>\n",
                            "      <td>4144014407</td>\n",
                            "      <td>广东省</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>专科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2026</th>\n",
                            "      <td>2027</td>\n",
                            "      <td>广东生态工程职业学院</td>\n",
                            "      <td>4144014509</td>\n",
                            "      <td>广东省</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>专科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2032</th>\n",
                            "      <td>2033</td>\n",
                            "      <td>广州卫生职业技术学院</td>\n",
                            "      <td>4144014592</td>\n",
                            "      <td>广东省</td>\n",
                            "      <td>广州市</td>\n",
                            "      <td>专科</td>\n",
                            "      <td>NaN</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "<p>82 rows × 7 columns</p>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 16
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 6,
            "source": [
                "import numpy as np\r\n"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "2740"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 6
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": null,
            "source": [],
            "outputs": [],
            "metadata": {}
        }
    ],
    "metadata": {
        "orig_nbformat": 4,
        "language_info": {
            "name": "python",
            "version": "3.9.6",
            "mimetype": "text/x-python",
            "codemirror_mode": {
                "name": "ipython",
                "version": 3
            },
            "pygments_lexer": "ipython3",
            "nbconvert_exporter": "python",
            "file_extension": ".py"
        },
        "kernelspec": {
            "name": "python3",
            "display_name": "Python 3.9.6 64-bit"
        },
        "interpreter": {
            "hash": "e4d85d63baa40a9854e1e91e14fde8d7f9b9a564a40f3bc91b58b47abf2bd79f"
        }
    },
    "nbformat": 4,
    "nbformat_minor": 2
}